Search Results for "clipper organic rooibos tea fairtrade caffeine free with antioxidants"

KroMLand Farm | Rooibos Caramel | 4 x 40...

View to See Price

View

Add to Cart

Heath & Heather | Organic Rooibos Te...

View to See Price

View

Add to Cart

Heath & Heather | Organic Rooibos Te...

View to See Price

View

Add to Cart

African Extracts Rooibos Nourishing Nigh...

View to See Price

View

Add to Cart

Dragonfly Rooibos Breakfast Tea 40 per p...

View to See Price

View

Add to Cart

CHEF SAUCE Rooibos - Bouteille pour té v...

only €12,13

View

Add to Cart

Elite Gift Boxes Boîte carrée à thé 'Tea...

only €12,71

View

Add to Cart

Storeindya Merci Donnant Handcrafred Boî...

View to See Price

View

Add to Cart

Rooibos Grenade Fraise Mandarine Before/...

View to See Price

View

Add to Cart

PLAT FIRM GRAINES DE Germination: Selten...

View to See Price

View

Add to Cart

Boîte à thé – Petit carré 100 GM – Teati...

View to See Price

View

Add to Cart

Faith | Pomegranate/Rooibos Bath Gel | 6...

View to See Price

View

Add to Cart

Yogi Tea ROOIBOS 17 FILTRES BIO

View to See Price

View

Add to Cart

Betty Boop Boîte à thé Betty S Tea and P...

View to See Price

View

Add to Cart

Zeller 19160 Boîte à thé avec Rabat Tea,...

View to See Price

View

Add to Cart

Portal Cool Graines rares/Plantes * Rooi...

only €9,78

View

Add to Cart

Dragonfly Rooibos Breakfast Tea 40 per p...

View to See Price

View

Add to Cart

Portal Cool 20 Graines rares Aspalathus ...

only €9,78

View

Add to Cart

361 to 378 of 438 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.4917371273041	384	1.0506	0

No Amazon API Requests Made.

App Debug - Total Time 1.4917371273041 seconds

Number	Time From Start	Name	Description
1	0.40343403816223	Initialise	Initialise FSB Function
2	0.40521311759949	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.45587110519409	Start of getCategoryListByGroup Function	Before first category groups query
4	0.45626211166382	After initial query	Before first category groups query
5	0.45626211166382	Get Category List for Group	Before the call to getCategoryList function
6	0.45626401901245	Start of GetCategoryList function	Start of the function
7	0.45626497268677	Before getting categories	Query to get specific category list
8	0.456876039505	After getting categories	Query to get specific category list
9	0.45687699317932	Before getting category custom	Before call to function getCategoryCustom
10	0.47694897651672	After getting category custom	After call to function getCategoryCustom
11	0.47695112228394	Before getting category custom	Before call to function getCategoryCustom
12	0.48600006103516	After getting category custom	After call to function getCategoryCustom
13	0.48600101470947	Before getting category custom	Before call to function getCategoryCustom
14	0.49113607406616	After getting category custom	After call to function getCategoryCustom
15	0.49113702774048	Before getting category custom	Before call to function getCategoryCustom
16	0.49442911148071	After getting category custom	After call to function getCategoryCustom
17	0.49443101882935	Before getting category custom	Before call to function getCategoryCustom
18	0.49771094322205	After getting category custom	After call to function getCategoryCustom
19	0.49771213531494	Before getting category custom	Before call to function getCategoryCustom
20	0.50092506408691	After getting category custom	After call to function getCategoryCustom
21	0.50092697143555	End of GetCategoryList function	End of the function
22	0.50093197822571	Get Category List for Group	Before the call to getCategoryList function
23	0.50093412399292	Start of GetCategoryList function	Start of the function
24	0.50093507766724	Before getting categories	Query to get specific category list
25	0.50130105018616	End of getCategoryListByGroup Function	Before return()
26	1.2985999584198	App Controller End	End of the App controller (called before the controller of every page)
27	1.4177701473236	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.418564081192	Before Get Options	Before the call to getOptions in the tpl class
29	1.4541840553284	After Get Options	After the call to getOptions in the tpl class
30	1.4542231559753	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.4917240142822	Finalizing debug	Before the debug is output to the page.
32	1.4917359352112	End of App	This is the end of the app logging, final timestamp

Query Debug - 384 Database Queries. Total time 1.0506 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.173\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751516307'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
SELECT * FROM pages WHERE id = 52
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'search'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.173') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.173') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'search'
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'clipper organic rooibos tea fairtrade caffeine free with antioxidants', NOW(), '216.73.216.173'
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'clipper') OR (keyfeatures LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (keyfeatures LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (keyfeatures LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (keyfeatures LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (keyfeatures LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (keyfeatures LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (keyfeatures LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (keyfeatures LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (keyfeatures LIKE 'antioxidants') OR (title LIKE 'antioxidants'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (title LIKE 'antioxidants'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (title LIKE 'antioxidants'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%clipper%') OR (keyfeatures LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (keyfeatures LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (keyfeatures LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (keyfeatures LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (keyfeatures LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (keyfeatures LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (keyfeatures LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (keyfeatures LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (keyfeatures LIKE '%antioxidants%') OR (title LIKE '%antioxidants%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (title LIKE '%antioxidants%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (title LIKE '%antioxidants%'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'clipper') OR (keyfeatures LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (keyfeatures LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (keyfeatures LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (keyfeatures LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (keyfeatures LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (keyfeatures LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (keyfeatures LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (keyfeatures LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (keyfeatures LIKE 'antioxidants') OR (title LIKE 'antioxidants'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (title LIKE 'antioxidants'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (title LIKE 'antioxidants'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%clipper%') OR (keyfeatures LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (keyfeatures LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (keyfeatures LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (keyfeatures LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (keyfeatures LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (keyfeatures LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (keyfeatures LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (keyfeatures LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (keyfeatures LIKE '%antioxidants%') OR (title LIKE '%antioxidants%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (title LIKE '%antioxidants%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (title LIKE '%antioxidants%'))
		AND hide = 0
SELECT * FROM products WHERE id = '2516'
SELECT * FROM productimages WHERE product_id = '2516' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2516'
SELECT * FROM productcustomimages WHERE product_id = '2516'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2516' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2516' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2516' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2516
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2516'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2516' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2519'
SELECT * FROM productimages WHERE product_id = '2519' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2519' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2519'
SELECT * FROM productcustomimages WHERE product_id = '2519'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2519'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2519'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2519
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2519' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2519' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2519' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2519
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2519'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2519'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2519'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2519
SELECT value FROM productattributes WHERE product_id = '2519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2519'
SELECT * FROM products WHERE id = '2520'
SELECT * FROM productimages WHERE product_id = '2520' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2520' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2520'
SELECT * FROM productcustomimages WHERE product_id = '2520'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2520'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2520'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2520
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2520' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2520' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2520' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2520
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2520'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2520'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2520'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2520
SELECT value FROM productattributes WHERE product_id = '2520' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2520'
SELECT * FROM products WHERE id = '2564'
SELECT * FROM productimages WHERE product_id = '2564' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2564'
SELECT * FROM productcustomimages WHERE product_id = '2564'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2564' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2564' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2564
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2564'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2564' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2686'
SELECT * FROM productimages WHERE product_id = '2686' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2686'
SELECT * FROM productcustomimages WHERE product_id = '2686'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2686' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2686' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2686' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2686
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2686'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2686' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2674'
SELECT * FROM productimages WHERE product_id = '2674' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2674'
SELECT * FROM productcustomimages WHERE product_id = '2674'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2674' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2674' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2674' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2674
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2674'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4127'
SELECT * FROM productimages WHERE product_id = '4127' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4127'
SELECT * FROM productcustomimages WHERE product_id = '4127'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4127' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4127' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4127' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4127' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2983'
SELECT * FROM productimages WHERE product_id = '2983' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2983'
SELECT * FROM productcustomimages WHERE product_id = '2983'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2983' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2983' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2983' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2983
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2983'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2829'
SELECT * FROM productimages WHERE product_id = '2829' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2829'
SELECT * FROM productcustomimages WHERE product_id = '2829'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2829' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2829' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2829' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2829
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2829'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2882'
SELECT * FROM productimages WHERE product_id = '2882' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2882'
SELECT * FROM productcustomimages WHERE product_id = '2882'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2882' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2882' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2882' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2882
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2882'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2882' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2984'
SELECT * FROM productimages WHERE product_id = '2984' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2984'
SELECT * FROM productcustomimages WHERE product_id = '2984'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2984' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2984' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2984' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2984
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2984'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2984' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3058'
SELECT * FROM productimages WHERE product_id = '3058' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3058'
SELECT * FROM productcustomimages WHERE product_id = '3058'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3058' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3058' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3058' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3058
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3058'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3168'
SELECT * FROM productimages WHERE product_id = '3168' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3168'
SELECT * FROM productcustomimages WHERE product_id = '3168'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3168' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3168' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3168' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3168
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3168'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3168' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3325'
SELECT * FROM productimages WHERE product_id = '3325' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3325'
SELECT * FROM productcustomimages WHERE product_id = '3325'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3325' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3325' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3325' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3325
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3325'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3325' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3166'
SELECT * FROM productimages WHERE product_id = '3166' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3166'
SELECT * FROM productcustomimages WHERE product_id = '3166'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3166' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3166' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3166' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3166
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3166'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3166' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3171'
SELECT * FROM productimages WHERE product_id = '3171' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3171'
SELECT * FROM productcustomimages WHERE product_id = '3171'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3171' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3171' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3171' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3171
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3171'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3171' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3252'
SELECT * FROM productimages WHERE product_id = '3252' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3252'
SELECT * FROM productcustomimages WHERE product_id = '3252'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3252' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3252' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3252' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3252
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3252'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3252' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3281'
SELECT * FROM productimages WHERE product_id = '3281' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3281'
SELECT * FROM productcustomimages WHERE product_id = '3281'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3281' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3281' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3281' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3281
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3281'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3281' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2516' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2519' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2520' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2564' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2686' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2674' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4127' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2983' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2829' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2882' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2984' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3058' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3168' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3325' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3166' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3171' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3252' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3281' ORDER BY timestamp DESC
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT * FROM products WHERE id = 1626
SELECT * FROM products WHERE id = 4041
SELECT * FROM products WHERE id = 4312
SELECT * FROM products WHERE id = 777
SELECT * FROM products WHERE id = 3881
SELECT * FROM products WHERE id = 4213
SELECT * FROM products WHERE id = '1626'
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1626'
SELECT * FROM productcustomimages WHERE product_id = '1626'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4041'
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4041'
SELECT * FROM productcustomimages WHERE product_id = '4041'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4312'
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4312'
SELECT * FROM productcustomimages WHERE product_id = '4312'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '777'
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '777'
SELECT * FROM productcustomimages WHERE product_id = '777'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3881'
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3881'
SELECT * FROM productcustomimages WHERE product_id = '3881'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4213'
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4213'
SELECT * FROM productcustomimages WHERE product_id = '4213'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0008	0.00076508522033691	SELECT parameter, value FROM parameters
2	0.0021	0.0021469593048096	SELECT * FROM `bad_bots`
3	0.0002	0.00021505355834961	SET time_zone = 'Europe/London'
4	0.0004	0.00036406517028809	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0004	0.00041794776916504	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.173\";}'
6	0.0004	0.00036001205444336	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751516307'
7	0.0008	0.0008389949798584	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0004	0.0003819465637207	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0006	0.00057482719421387	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0006	0.00058913230895996	SELECT * FROM pages WHERE id = 52
11	0.0026	0.0026199817657471	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0473	0.047291994094849	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0003	0.00034403800964355	SELECT * FROM pages WHERE pagename = 'search'
14	0.0004	0.00038599967956543	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0006	0.00060176849365234	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0098	0.0098249912261963	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17	0.0006	0.00055408477783203	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0004	0.00042104721069336	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0004	0.00044393539428711	SELECT id FROM categories WHERE parent_id = '26'
20	0.0073	0.0072510242462158	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
21	0.0004	0.0004279613494873	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (26) AND p.disabled = 0
22	0.0004	0.00036787986755371	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (26) AND c.prod_type = 'custom' AND cp.hide = 0
23	0.0004	0.00038290023803711	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0003	0.00034499168395996	SELECT * FROM categorygroups WHERE id = '1'
25	0.0030	0.0029799938201904	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26	0.0003	0.00032806396484375	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0003	0.0003049373626709	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0003	0.00031614303588867	SELECT id FROM categories WHERE parent_id = '27'
29	0.0038	0.0038039684295654	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
30	0.0003	0.00034594535827637	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0003	0.00034594535827637	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
32	0.0003	0.00030684471130371	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0003	0.00028491020202637	SELECT * FROM categorygroups WHERE id = '1'
34	0.0014	0.0014421939849854	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0006	0.00060200691223145	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36	0.0003	0.00027108192443848	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0003	0.00029897689819336	SELECT id FROM categories WHERE parent_id = '28'
38	0.0012	0.001194953918457	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
39	0.0004	0.00036215782165527	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
40	0.0003	0.0003359317779541	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
41	0.0003	0.00032591819763184	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0003	0.00028085708618164	SELECT * FROM categorygroups WHERE id = '1'
43	0.0004	0.00037693977355957	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0003	0.00031900405883789	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45	0.0003	0.00027203559875488	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0003	0.0003058910369873	SELECT id FROM categories WHERE parent_id = '29'
47	0.0007	0.00068879127502441	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
48	0.0003	0.00034093856811523	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
49	0.0003	0.00034213066101074	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
50	0.0003	0.00031614303588867	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0003	0.00030303001403809	SELECT * FROM categorygroups WHERE id = '1'
52	0.0004	0.00037312507629395	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53	0.0003	0.00029778480529785	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54	0.0003	0.0002739429473877	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0003	0.00030016899108887	SELECT id FROM categories WHERE parent_id = '30'
56	0.0004	0.00041985511779785	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
57	0.0003	0.00032210350036621	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
58	0.0005	0.00049209594726562	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
59	0.0003	0.00032615661621094	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0004	0.00042986869812012	SELECT * FROM categorygroups WHERE id = '1'
61	0.0004	0.00041604042053223	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62	0.0003	0.00030899047851562	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63	0.0003	0.00028514862060547	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0003	0.00028204917907715	SELECT id FROM categories WHERE parent_id = '31'
65	0.0005	0.00045394897460938	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
66	0.0003	0.00033903121948242	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
67	0.0004	0.00036096572875977	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
68	0.0003	0.00030899047851562	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0004	0.00042200088500977	SELECT * FROM categorygroups WHERE id = '1'
70	0.0004	0.00036001205444336	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0014	0.0014429092407227	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0004	0.00042009353637695	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0004	0.00036215782165527	SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74	0.0003	0.00027704238891602	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0009	0.00092577934265137	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0009	0.00086784362792969	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.7909	0.7908890247345	SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.173') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.173') <= INET_ATON(ip_end)
78	0.0010	0.0010089874267578	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0003	0.00031709671020508	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0003	0.0002892017364502	SELECT * FROM pages WHERE pagename = 'search'
81	0.0059	0.0059099197387695	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82	0.0017	0.0016779899597168	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83	0.0006	0.00059008598327637	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84	0.0068	0.0067620277404785	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0014	0.0013949871063232	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0004	0.00040698051452637	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87	0.0020	0.0019969940185547	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'clipper organic rooibos tea fairtrade caffeine free with antioxidants', NOW(), '216.73.216.173'
88	0.0012	0.0011970996856689	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
89	0.0013	0.0013270378112793	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0039	0.0038588047027588	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE 'clipper') OR (keyfeatures LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (keyfeatures LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (keyfeatures LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (keyfeatures LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (keyfeatures LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (keyfeatures LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (keyfeatures LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (keyfeatures LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (keyfeatures LIKE 'antioxidants') OR (title LIKE 'antioxidants')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
91	0.0003	0.00034403800964355	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (title LIKE 'antioxidants')) AND hide = 0
92	0.0003	0.00032901763916016	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (title LIKE 'antioxidants')) AND hide = 0
93	0.0003	0.00032305717468262	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
94	0.0069	0.0069000720977783	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%clipper%') OR (keyfeatures LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (keyfeatures LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (keyfeatures LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (keyfeatures LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (keyfeatures LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (keyfeatures LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (keyfeatures LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (keyfeatures LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (keyfeatures LIKE '%antioxidants%') OR (title LIKE '%antioxidants%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
95	0.0003	0.00025606155395508	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (title LIKE '%antioxidants%')) AND hide = 0
96	0.0002	0.00022506713867188	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (title LIKE '%antioxidants%')) AND hide = 0
97	0.0004	0.00035500526428223	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
98	0.0003	0.00033712387084961	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0038	0.0038199424743652	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE 'clipper') OR (keyfeatures LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (keyfeatures LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (keyfeatures LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (keyfeatures LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (keyfeatures LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (keyfeatures LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (keyfeatures LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (keyfeatures LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (keyfeatures LIKE 'antioxidants') OR (title LIKE 'antioxidants')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0003	0.00026488304138184	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (title LIKE 'antioxidants')) AND hide = 0
101	0.0002	0.00023603439331055	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE 'clipper') OR (title LIKE 'clipper') OR (description LIKE 'organic') OR (title LIKE 'organic') OR (description LIKE 'rooibos') OR (title LIKE 'rooibos') OR (description LIKE 'tea') OR (title LIKE 'tea') OR (description LIKE 'fairtrade') OR (title LIKE 'fairtrade') OR (description LIKE 'caffeine') OR (title LIKE 'caffeine') OR (description LIKE 'free') OR (title LIKE 'free') OR (description LIKE 'with') OR (title LIKE 'with') OR (description LIKE 'antioxidants') OR (title LIKE 'antioxidants')) AND hide = 0
102	0.0003	0.00031805038452148	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+clipper +organic +rooib} +tea +fairtrade +caffeine +free +with +antioxidan}' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
103	0.0068	0.0068011283874512	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%clipper%') OR (keyfeatures LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (keyfeatures LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (keyfeatures LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (keyfeatures LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (keyfeatures LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (keyfeatures LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (keyfeatures LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (keyfeatures LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (keyfeatures LIKE '%antioxidants%') OR (title LIKE '%antioxidants%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0003	0.00026583671569824	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (title LIKE '%antioxidants%')) AND hide = 0
105	0.0002	0.00022506713867188	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%clipper%') OR (title LIKE '%clipper%') OR (description LIKE '%organic%') OR (title LIKE '%organic%') OR (description LIKE '%rooibos%') OR (title LIKE '%rooibos%') OR (description LIKE '%tea%') OR (title LIKE '%tea%') OR (description LIKE '%fairtrade%') OR (title LIKE '%fairtrade%') OR (description LIKE '%caffeine%') OR (title LIKE '%caffeine%') OR (description LIKE '%free%') OR (title LIKE '%free%') OR (description LIKE '%with%') OR (title LIKE '%with%') OR (description LIKE '%antioxidants%') OR (title LIKE '%antioxidants%')) AND hide = 0
106	0.0003	0.00027585029602051	SELECT * FROM products WHERE id = '2516'
107	0.0003	0.00032210350036621	SELECT * FROM productimages WHERE product_id = '2516' ORDER BY sortorder ASC
108	0.0004	0.00044512748718262	SELECT * FROM product_image_select WHERE product_id = '2516'
109	0.0003	0.00026822090148926	SELECT * FROM productcustomimages WHERE product_id = '2516'
110	0.0006	0.00057196617126465	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2516' AND a.name = n.originalname
111	0.0003	0.00031590461730957	SELECT * FROM productoffers WHERE product_id = '2516' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0002	0.00024199485778809	SELECT * FROM productoffers WHERE product_id = '2516' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0002	0.00021910667419434	SELECT * FROM productoffers WHERE product_id = 2516 ORDER BY price ASC LIMIT 1
114	0.0003	0.00025010108947754	SELECT value FROM productattributes WHERE product_id = '2516' AND name = 'ListPriceAmount'
115	0.0003	0.00025296211242676	SELECT value FROM productattributes WHERE product_id = '2516' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116	0.0003	0.00031208992004395	SELECT * FROM products WHERE id = '2519'
117	0.0004	0.0003659725189209	SELECT * FROM productimages WHERE product_id = '2519' ORDER BY sortorder ASC
118	0.0002	0.00024890899658203	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2519' AND p.id = pi.product_id ORDER BY pi.sortorder
119	0.0004	0.00043296813964844	SELECT * FROM product_image_select WHERE product_id = '2519'
120	0.0003	0.00025701522827148	SELECT * FROM productcustomimages WHERE product_id = '2519'
121	0.0003	0.00031805038452148	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '2519' GROUP BY o.product_id
122	0.0013	0.0013470649719238	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '2519' GROUP BY n.displayname ORDER BY n.displayname DESC
123	0.0003	0.00029683113098145	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2519
124	0.0007	0.00065803527832031	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2519' AND a.name = n.originalname
125	0.0002	0.00022792816162109	SELECT * FROM productoffers WHERE product_id = '2519' AND merchantid = 'A1X6FK5RDHNB96'
126	0.0002	0.00022602081298828	SELECT * FROM productoffers WHERE product_id = '2519' AND price > 0 ORDER BY price ASC LIMIT 1
127	0.0002	0.00021004676818848	SELECT * FROM productoffers WHERE product_id = 2519 ORDER BY price ASC LIMIT 1
128	0.0002	0.00022792816162109	SELECT value FROM productattributes WHERE product_id = '2519' AND name = 'ListPriceAmount'
129	0.0002	0.00023603439331055	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '2519' GROUP BY o.product_id
130	0.0003	0.00034594535827637	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '2519' GROUP BY n.displayname ORDER BY n.displayname DESC
131	0.0002	0.00022196769714355	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2519
132	0.0003	0.00032806396484375	SELECT value FROM productattributes WHERE product_id = '2519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133	0.0002	0.000244140625	SELECT * FROM products WHERE parent_id = '2519'
134	0.0003	0.00033211708068848	SELECT * FROM products WHERE id = '2520'
135	0.0004	0.00037407875061035	SELECT * FROM productimages WHERE product_id = '2520' ORDER BY sortorder ASC
136	0.0003	0.00025200843811035	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2520' AND p.id = pi.product_id ORDER BY pi.sortorder
137	0.0004	0.00043106079101562	SELECT * FROM product_image_select WHERE product_id = '2520'
138	0.0003	0.00026297569274902	SELECT * FROM productcustomimages WHERE product_id = '2520'
139	0.0003	0.00031089782714844	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '2520' GROUP BY o.product_id
140	0.0004	0.00035500526428223	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '2520' GROUP BY n.displayname ORDER BY n.displayname DESC
141	0.0002	0.00023508071899414	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2520
142	0.0006	0.00063800811767578	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2520' AND a.name = n.originalname
143	0.0002	0.00023198127746582	SELECT * FROM productoffers WHERE product_id = '2520' AND merchantid = 'A1X6FK5RDHNB96'
144	0.0002	0.00023102760314941	SELECT * FROM productoffers WHERE product_id = '2520' AND price > 0 ORDER BY price ASC LIMIT 1
145	0.0002	0.00021886825561523	SELECT * FROM productoffers WHERE product_id = 2520 ORDER BY price ASC LIMIT 1
146	0.0002	0.00023984909057617	SELECT value FROM productattributes WHERE product_id = '2520' AND name = 'ListPriceAmount'
147	0.0003	0.0002601146697998	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '2520' GROUP BY o.product_id
148	0.0004	0.00037097930908203	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '2520' GROUP BY n.displayname ORDER BY n.displayname DESC
149	0.0002	0.00023293495178223	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2520
150	0.0003	0.00032877922058105	SELECT value FROM productattributes WHERE product_id = '2520' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151	0.0002	0.00024819374084473	SELECT * FROM products WHERE parent_id = '2520'
152	0.0003	0.00028705596923828	SELECT * FROM products WHERE id = '2564'
153	0.0004	0.0003809928894043	SELECT * FROM productimages WHERE product_id = '2564' ORDER BY sortorder ASC
154	0.0004	0.00041913986206055	SELECT * FROM product_image_select WHERE product_id = '2564'
155	0.0003	0.00025200843811035	SELECT * FROM productcustomimages WHERE product_id = '2564'
156	0.0006	0.00058197975158691	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname
157	0.0003	0.0002899169921875	SELECT * FROM productoffers WHERE product_id = '2564' AND merchantid = 'A1X6FK5RDHNB96'
158	0.0002	0.00023317337036133	SELECT * FROM productoffers WHERE product_id = '2564' AND price > 0 ORDER BY price ASC LIMIT 1
159	0.0002	0.0002129077911377	SELECT * FROM productoffers WHERE product_id = 2564 ORDER BY price ASC LIMIT 1
160	0.0003	0.00026321411132812	SELECT value FROM productattributes WHERE product_id = '2564' AND name = 'ListPriceAmount'
161	0.0003	0.00025320053100586	SELECT value FROM productattributes WHERE product_id = '2564' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162	0.0003	0.00031900405883789	SELECT * FROM products WHERE id = '2686'
163	0.0004	0.00041604042053223	SELECT * FROM productimages WHERE product_id = '2686' ORDER BY sortorder ASC
164	0.0004	0.00042104721069336	SELECT * FROM product_image_select WHERE product_id = '2686'
165	0.0003	0.00025391578674316	SELECT * FROM productcustomimages WHERE product_id = '2686'
166	0.0005	0.00054216384887695	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2686' AND a.name = n.originalname
167	0.0003	0.00029397010803223	SELECT * FROM productoffers WHERE product_id = '2686' AND merchantid = 'A1X6FK5RDHNB96'
168	0.0002	0.00023794174194336	SELECT * FROM productoffers WHERE product_id = '2686' AND price > 0 ORDER BY price ASC LIMIT 1
169	0.0002	0.00021600723266602	SELECT * FROM productoffers WHERE product_id = 2686 ORDER BY price ASC LIMIT 1
170	0.0002	0.00023293495178223	SELECT value FROM productattributes WHERE product_id = '2686' AND name = 'ListPriceAmount'
171	0.0003	0.00025200843811035	SELECT value FROM productattributes WHERE product_id = '2686' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172	0.0003	0.0003199577331543	SELECT * FROM products WHERE id = '2674'
173	0.0003	0.00030899047851562	SELECT * FROM productimages WHERE product_id = '2674' ORDER BY sortorder ASC
174	0.0004	0.00042510032653809	SELECT * FROM product_image_select WHERE product_id = '2674'
175	0.0003	0.00026202201843262	SELECT * FROM productcustomimages WHERE product_id = '2674'
176	0.0006	0.00063109397888184	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2674' AND a.name = n.originalname
177	0.0003	0.00029301643371582	SELECT * FROM productoffers WHERE product_id = '2674' AND merchantid = 'A1X6FK5RDHNB96'
178	0.0002	0.00023913383483887	SELECT * FROM productoffers WHERE product_id = '2674' AND price > 0 ORDER BY price ASC LIMIT 1
179	0.0002	0.0002129077911377	SELECT * FROM productoffers WHERE product_id = 2674 ORDER BY price ASC LIMIT 1
180	0.0002	0.00022482872009277	SELECT value FROM productattributes WHERE product_id = '2674' AND name = 'ListPriceAmount'
181	0.0002	0.00024914741516113	SELECT value FROM productattributes WHERE product_id = '2674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182	0.0003	0.00028896331787109	SELECT * FROM products WHERE id = '4127'
183	0.0004	0.00035905838012695	SELECT * FROM productimages WHERE product_id = '4127' ORDER BY sortorder ASC
184	0.0005	0.00045204162597656	SELECT * FROM product_image_select WHERE product_id = '4127'
185	0.0003	0.00025677680969238	SELECT * FROM productcustomimages WHERE product_id = '4127'
186	0.0005	0.00051283836364746	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4127' AND a.name = n.originalname
187	0.0003	0.00028395652770996	SELECT * FROM productoffers WHERE product_id = '4127' AND merchantid = 'A1X6FK5RDHNB96'
188	0.0002	0.00023913383483887	SELECT * FROM productoffers WHERE product_id = '4127' AND price > 0 ORDER BY price ASC LIMIT 1
189	0.0003	0.00032281875610352	SELECT value FROM productattributes WHERE product_id = '4127' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190	0.0003	0.00028395652770996	SELECT * FROM products WHERE id = '2983'
191	0.0004	0.00041794776916504	SELECT * FROM productimages WHERE product_id = '2983' ORDER BY sortorder ASC
192	0.0004	0.00042080879211426	SELECT * FROM product_image_select WHERE product_id = '2983'
193	0.0002	0.0002448558807373	SELECT * FROM productcustomimages WHERE product_id = '2983'
194	0.0007	0.00069594383239746	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2983' AND a.name = n.originalname
195	0.0003	0.00029611587524414	SELECT * FROM productoffers WHERE product_id = '2983' AND merchantid = 'A1X6FK5RDHNB96'
196	0.0002	0.0002439022064209	SELECT * FROM productoffers WHERE product_id = '2983' AND price > 0 ORDER BY price ASC LIMIT 1
197	0.0002	0.00021982192993164	SELECT * FROM productoffers WHERE product_id = 2983 ORDER BY price ASC LIMIT 1
198	0.0002	0.00023579597473145	SELECT value FROM productattributes WHERE product_id = '2983' AND name = 'ListPriceAmount'
199	0.0003	0.00025510787963867	SELECT value FROM productattributes WHERE product_id = '2983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200	0.0003	0.00030684471130371	SELECT * FROM products WHERE id = '2829'
201	0.0004	0.00037193298339844	SELECT * FROM productimages WHERE product_id = '2829' ORDER BY sortorder ASC
202	0.0004	0.00042200088500977	SELECT * FROM product_image_select WHERE product_id = '2829'
203	0.0003	0.00025296211242676	SELECT * FROM productcustomimages WHERE product_id = '2829'
204	0.0005	0.00054097175598145	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2829' AND a.name = n.originalname
205	0.0003	0.00029492378234863	SELECT * FROM productoffers WHERE product_id = '2829' AND merchantid = 'A1X6FK5RDHNB96'
206	0.0002	0.00023388862609863	SELECT * FROM productoffers WHERE product_id = '2829' AND price > 0 ORDER BY price ASC LIMIT 1
207	0.0002	0.000244140625	SELECT * FROM productoffers WHERE product_id = 2829 ORDER BY price ASC LIMIT 1
208	0.0002	0.00024104118347168	SELECT value FROM productattributes WHERE product_id = '2829' AND name = 'ListPriceAmount'
209	0.0003	0.00025701522827148	SELECT value FROM productattributes WHERE product_id = '2829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210	0.0003	0.00032401084899902	SELECT * FROM products WHERE id = '2882'
211	0.0004	0.00039911270141602	SELECT * FROM productimages WHERE product_id = '2882' ORDER BY sortorder ASC
212	0.0004	0.0004270076751709	SELECT * FROM product_image_select WHERE product_id = '2882'
213	0.0003	0.00025296211242676	SELECT * FROM productcustomimages WHERE product_id = '2882'
214	0.0006	0.00060606002807617	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2882' AND a.name = n.originalname
215	0.0003	0.00029206275939941	SELECT * FROM productoffers WHERE product_id = '2882' AND merchantid = 'A1X6FK5RDHNB96'
216	0.0003	0.00025391578674316	SELECT * FROM productoffers WHERE product_id = '2882' AND price > 0 ORDER BY price ASC LIMIT 1
217	0.0002	0.00021600723266602	SELECT * FROM productoffers WHERE product_id = 2882 ORDER BY price ASC LIMIT 1
218	0.0002	0.00023198127746582	SELECT value FROM productattributes WHERE product_id = '2882' AND name = 'ListPriceAmount'
219	0.0003	0.00025606155395508	SELECT value FROM productattributes WHERE product_id = '2882' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220	0.0004	0.00037288665771484	SELECT * FROM products WHERE id = '2984'
221	0.0004	0.00037789344787598	SELECT * FROM productimages WHERE product_id = '2984' ORDER BY sortorder ASC
222	0.0004	0.00041699409484863	SELECT * FROM product_image_select WHERE product_id = '2984'
223	0.0002	0.000244140625	SELECT * FROM productcustomimages WHERE product_id = '2984'
224	0.0005	0.00052690505981445	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2984' AND a.name = n.originalname
225	0.0003	0.00029397010803223	SELECT * FROM productoffers WHERE product_id = '2984' AND merchantid = 'A1X6FK5RDHNB96'
226	0.0002	0.00022411346435547	SELECT * FROM productoffers WHERE product_id = '2984' AND price > 0 ORDER BY price ASC LIMIT 1
227	0.0002	0.00020909309387207	SELECT * FROM productoffers WHERE product_id = 2984 ORDER BY price ASC LIMIT 1
228	0.0002	0.00023198127746582	SELECT value FROM productattributes WHERE product_id = '2984' AND name = 'ListPriceAmount'
229	0.0003	0.00025296211242676	SELECT value FROM productattributes WHERE product_id = '2984' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230	0.0003	0.0002899169921875	SELECT * FROM products WHERE id = '3058'
231	0.0003	0.00031805038452148	SELECT * FROM productimages WHERE product_id = '3058' ORDER BY sortorder ASC
232	0.0004	0.00044989585876465	SELECT * FROM product_image_select WHERE product_id = '3058'
233	0.0003	0.00026297569274902	SELECT * FROM productcustomimages WHERE product_id = '3058'
234	0.0006	0.00059604644775391	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3058' AND a.name = n.originalname
235	0.0003	0.00031089782714844	SELECT * FROM productoffers WHERE product_id = '3058' AND merchantid = 'A1X6FK5RDHNB96'
236	0.0003	0.0002598762512207	SELECT * FROM productoffers WHERE product_id = '3058' AND price > 0 ORDER BY price ASC LIMIT 1
237	0.0002	0.00022196769714355	SELECT * FROM productoffers WHERE product_id = 3058 ORDER BY price ASC LIMIT 1
238	0.0002	0.00022292137145996	SELECT value FROM productattributes WHERE product_id = '3058' AND name = 'ListPriceAmount'
239	0.0002	0.00024104118347168	SELECT value FROM productattributes WHERE product_id = '3058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240	0.0003	0.00030016899108887	SELECT * FROM products WHERE id = '3168'
241	0.0003	0.00030684471130371	SELECT * FROM productimages WHERE product_id = '3168' ORDER BY sortorder ASC
242	0.0004	0.00043821334838867	SELECT * FROM product_image_select WHERE product_id = '3168'
243	0.0003	0.00026679039001465	SELECT * FROM productcustomimages WHERE product_id = '3168'
244	0.0006	0.00057601928710938	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3168' AND a.name = n.originalname
245	0.0003	0.00030112266540527	SELECT * FROM productoffers WHERE product_id = '3168' AND merchantid = 'A1X6FK5RDHNB96'
246	0.0003	0.00025415420532227	SELECT * FROM productoffers WHERE product_id = '3168' AND price > 0 ORDER BY price ASC LIMIT 1
247	0.0002	0.00023007392883301	SELECT * FROM productoffers WHERE product_id = 3168 ORDER BY price ASC LIMIT 1
248	0.0003	0.00025796890258789	SELECT value FROM productattributes WHERE product_id = '3168' AND name = 'ListPriceAmount'
249	0.0003	0.00026297569274902	SELECT value FROM productattributes WHERE product_id = '3168' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250	0.0003	0.00033783912658691	SELECT * FROM products WHERE id = '3325'
251	0.0003	0.00034117698669434	SELECT * FROM productimages WHERE product_id = '3325' ORDER BY sortorder ASC
252	0.0004	0.00043702125549316	SELECT * FROM product_image_select WHERE product_id = '3325'
253	0.0003	0.0002601146697998	SELECT * FROM productcustomimages WHERE product_id = '3325'
254	0.0006	0.00059199333190918	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3325' AND a.name = n.originalname
255	0.0003	0.00031280517578125	SELECT * FROM productoffers WHERE product_id = '3325' AND merchantid = 'A1X6FK5RDHNB96'
256	0.0002	0.00024986267089844	SELECT * FROM productoffers WHERE product_id = '3325' AND price > 0 ORDER BY price ASC LIMIT 1
257	0.0002	0.00021791458129883	SELECT * FROM productoffers WHERE product_id = 3325 ORDER BY price ASC LIMIT 1
258	0.0002	0.00022292137145996	SELECT value FROM productattributes WHERE product_id = '3325' AND name = 'ListPriceAmount'
259	0.0002	0.00023698806762695	SELECT value FROM productattributes WHERE product_id = '3325' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260	0.0003	0.00030207633972168	SELECT * FROM products WHERE id = '3166'
261	0.0003	0.00033092498779297	SELECT * FROM productimages WHERE product_id = '3166' ORDER BY sortorder ASC
262	0.0004	0.00041389465332031	SELECT * FROM product_image_select WHERE product_id = '3166'
263	0.0003	0.00025296211242676	SELECT * FROM productcustomimages WHERE product_id = '3166'
264	0.0006	0.00061798095703125	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3166' AND a.name = n.originalname
265	0.0003	0.00028586387634277	SELECT * FROM productoffers WHERE product_id = '3166' AND merchantid = 'A1X6FK5RDHNB96'
266	0.0002	0.00023007392883301	SELECT * FROM productoffers WHERE product_id = '3166' AND price > 0 ORDER BY price ASC LIMIT 1
267	0.0002	0.00020909309387207	SELECT * FROM productoffers WHERE product_id = 3166 ORDER BY price ASC LIMIT 1
268	0.0002	0.00022697448730469	SELECT value FROM productattributes WHERE product_id = '3166' AND name = 'ListPriceAmount'
269	0.0005	0.0005190372467041	SELECT value FROM productattributes WHERE product_id = '3166' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270	0.0003	0.00030517578125	SELECT * FROM products WHERE id = '3171'
271	0.0003	0.00033402442932129	SELECT * FROM productimages WHERE product_id = '3171' ORDER BY sortorder ASC
272	0.0005	0.00045609474182129	SELECT * FROM product_image_select WHERE product_id = '3171'
273	0.0003	0.00025796890258789	SELECT * FROM productcustomimages WHERE product_id = '3171'
274	0.0006	0.00060486793518066	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3171' AND a.name = n.originalname
275	0.0003	0.00030279159545898	SELECT * FROM productoffers WHERE product_id = '3171' AND merchantid = 'A1X6FK5RDHNB96'
276	0.0002	0.0002288818359375	SELECT * FROM productoffers WHERE product_id = '3171' AND price > 0 ORDER BY price ASC LIMIT 1
277	0.0002	0.00022101402282715	SELECT * FROM productoffers WHERE product_id = 3171 ORDER BY price ASC LIMIT 1
278	0.0002	0.00023102760314941	SELECT value FROM productattributes WHERE product_id = '3171' AND name = 'ListPriceAmount'
279	0.0002	0.00024604797363281	SELECT value FROM productattributes WHERE product_id = '3171' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280	0.0003	0.00032782554626465	SELECT * FROM products WHERE id = '3252'
281	0.0004	0.00037097930908203	SELECT * FROM productimages WHERE product_id = '3252' ORDER BY sortorder ASC
282	0.0004	0.00042104721069336	SELECT * FROM product_image_select WHERE product_id = '3252'
283	0.0005	0.00046586990356445	SELECT * FROM productcustomimages WHERE product_id = '3252'
284	0.0012	0.0011670589447021	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3252' AND a.name = n.originalname
285	0.0004	0.00039982795715332	SELECT * FROM productoffers WHERE product_id = '3252' AND merchantid = 'A1X6FK5RDHNB96'
286	0.0002	0.00022983551025391	SELECT * FROM productoffers WHERE product_id = '3252' AND price > 0 ORDER BY price ASC LIMIT 1
287	0.0002	0.00021100044250488	SELECT * FROM productoffers WHERE product_id = 3252 ORDER BY price ASC LIMIT 1
288	0.0002	0.00023293495178223	SELECT value FROM productattributes WHERE product_id = '3252' AND name = 'ListPriceAmount'
289	0.0002	0.0002448558807373	SELECT value FROM productattributes WHERE product_id = '3252' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290	0.0006	0.00055217742919922	SELECT * FROM products WHERE id = '3281'
291	0.0004	0.0003669261932373	SELECT * FROM productimages WHERE product_id = '3281' ORDER BY sortorder ASC
292	0.0007	0.00070786476135254	SELECT * FROM product_image_select WHERE product_id = '3281'
293	0.0003	0.00027084350585938	SELECT * FROM productcustomimages WHERE product_id = '3281'
294	0.0007	0.00065398216247559	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3281' AND a.name = n.originalname
295	0.0003	0.00031208992004395	SELECT * FROM productoffers WHERE product_id = '3281' AND merchantid = 'A1X6FK5RDHNB96'
296	0.0002	0.00023794174194336	SELECT * FROM productoffers WHERE product_id = '3281' AND price > 0 ORDER BY price ASC LIMIT 1
297	0.0002	0.0002288818359375	SELECT * FROM productoffers WHERE product_id = 3281 ORDER BY price ASC LIMIT 1
298	0.0002	0.00024080276489258	SELECT value FROM productattributes WHERE product_id = '3281' AND name = 'ListPriceAmount'
299	0.0003	0.00028896331787109	SELECT value FROM productattributes WHERE product_id = '3281' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
300	0.0003	0.00031495094299316	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2516' ORDER BY timestamp DESC
301	0.0002	0.00021696090698242	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2519' ORDER BY timestamp DESC
302	0.0002	0.00019598007202148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2520' ORDER BY timestamp DESC
303	0.0003	0.0003209114074707	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2564' ORDER BY timestamp DESC
304	0.0002	0.00020599365234375	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2686' ORDER BY timestamp DESC
305	0.0004	0.00039410591125488	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2674' ORDER BY timestamp DESC
306	0.0004	0.00035500526428223	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4127' ORDER BY timestamp DESC
307	0.0003	0.00027799606323242	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2983' ORDER BY timestamp DESC
308	0.0003	0.00026702880859375	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2829' ORDER BY timestamp DESC
309	0.0003	0.00032281875610352	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2882' ORDER BY timestamp DESC
310	0.0003	0.00026702880859375	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2984' ORDER BY timestamp DESC
311	0.0002	0.0001990795135498	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3058' ORDER BY timestamp DESC
312	0.0002	0.00019598007202148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3168' ORDER BY timestamp DESC
313	0.0002	0.00018501281738281	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3325' ORDER BY timestamp DESC
314	0.0002	0.00018596649169922	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3166' ORDER BY timestamp DESC
315	0.0002	0.00019598007202148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3171' ORDER BY timestamp DESC
316	0.0004	0.00038003921508789	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3252' ORDER BY timestamp DESC
317	0.0002	0.00018787384033203	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3281' ORDER BY timestamp DESC
318	0.0003	0.00033211708068848	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
319	0.0004	0.0003821849822998	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
320	0.0004	0.00035810470581055	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
321	0.0115	0.01154088973999	SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
322	0.0005	0.00045013427734375	SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
323	0.0003	0.00033903121948242	SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
324	0.0003	0.00031685829162598	SELECT * FROM products WHERE id = 1626
325	0.0003	0.00034284591674805	SELECT * FROM products WHERE id = 4041
326	0.0003	0.00031614303588867	SELECT * FROM products WHERE id = 4312
327	0.0003	0.00030612945556641	SELECT * FROM products WHERE id = 777
328	0.0004	0.00036096572875977	SELECT * FROM products WHERE id = 3881
329	0.0003	0.00033712387084961	SELECT * FROM products WHERE id = 4213
330	0.0003	0.00033712387084961	SELECT * FROM products WHERE id = '1626'
331	0.0004	0.00037217140197754	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
332	0.0004	0.00043082237243652	SELECT * FROM product_image_select WHERE product_id = '1626'
333	0.0003	0.00026297569274902	SELECT * FROM productcustomimages WHERE product_id = '1626'
334	0.0006	0.00055480003356934	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
335	0.0003	0.00032496452331543	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
336	0.0003	0.0002601146697998	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
337	0.0003	0.00033116340637207	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
338	0.0003	0.00030088424682617	SELECT * FROM products WHERE id = '4041'
339	0.0004	0.00039887428283691	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
340	0.0004	0.00043487548828125	SELECT * FROM product_image_select WHERE product_id = '4041'
341	0.0003	0.0002601146697998	SELECT * FROM productcustomimages WHERE product_id = '4041'
342	0.0007	0.00066995620727539	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
343	0.0003	0.00030899047851562	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
344	0.0003	0.00026297569274902	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
345	0.0003	0.0003199577331543	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
346	0.0003	0.0003058910369873	SELECT * FROM products WHERE id = '4312'
347	0.0004	0.00035715103149414	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
348	0.0004	0.00042891502380371	SELECT * FROM product_image_select WHERE product_id = '4312'
349	0.0003	0.00026202201843262	SELECT * FROM productcustomimages WHERE product_id = '4312'
350	0.0007	0.00066018104553223	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
351	0.0003	0.00030303001403809	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
352	0.0003	0.00025796890258789	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
353	0.0003	0.00029587745666504	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
354	0.0003	0.00030803680419922	SELECT * FROM products WHERE id = '777'
355	0.0003	0.00034117698669434	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
356	0.0004	0.00043392181396484	SELECT * FROM product_image_select WHERE product_id = '777'
357	0.0003	0.0002589225769043	SELECT * FROM productcustomimages WHERE product_id = '777'
358	0.0006	0.00062894821166992	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
359	0.0003	0.00030279159545898	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
360	0.0003	0.00028300285339355	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
361	0.0003	0.00029897689819336	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
362	0.0003	0.00030899047851562	SELECT * FROM products WHERE id = '3881'
363	0.0004	0.00037503242492676	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
364	0.0005	0.00046110153198242	SELECT * FROM product_image_select WHERE product_id = '3881'
365	0.0003	0.00025606155395508	SELECT * FROM productcustomimages WHERE product_id = '3881'
366	0.0006	0.00064897537231445	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
367	0.0003	0.00029993057250977	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
368	0.0003	0.00025415420532227	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
369	0.0003	0.00032591819763184	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
370	0.0003	0.00029897689819336	SELECT * FROM products WHERE id = '4213'
371	0.0004	0.00039219856262207	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
372	0.0005	0.00046396255493164	SELECT * FROM product_image_select WHERE product_id = '4213'
373	0.0003	0.0002739429473877	SELECT * FROM productcustomimages WHERE product_id = '4213'
374	0.0007	0.0006871223449707	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
375	0.0003	0.00029587745666504	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
376	0.0003	0.00028300285339355	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
377	0.0003	0.00029611587524414	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
378	0.0006	0.00057101249694824	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
379	0.0005	0.00045108795166016	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
380	0.0011	0.0010991096496582	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
381	0.0004	0.00043296813964844	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
382	0.0003	0.00034189224243164	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
383	0.0004	0.00038719177246094	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
384	0.0004	0.00036907196044922	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "clipper organic rooibos tea fairtrade caffeine free with antioxidants"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.4917371273041 seconds

Query Debug - 384 Database Queries. Total time 1.0506 seconds